Dataset statistics
| Number of variables | 41 |
|---|---|
| Number of observations | 70372 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 22.0 MiB |
| Average record size in memory | 328.0 B |
Variable types
| BOOL | 29 |
|---|---|
| NUM | 9 |
| CAT | 3 |
order_dt has a high cardinality: 2160 distinct values | High cardinality |
first_order_dt has a high cardinality: 2931 distinct values | High cardinality |
first_cont_dt has a high cardinality: 1398 distinct values | High cardinality |
tot_contribution_paid_amt is highly skewed (γ1 = 69.13668969) | Skewed |
Lifetime Giving is highly skewed (γ1 = 30.32802605) | Skewed |
tot_ticket_paid_amt has 34085 (48.4%) zeros | Zeros |
tot_contribution_paid_amt has 68563 (97.4%) zeros | Zeros |
Prelim Capacity has 30829 (43.8%) zeros | Zeros |
ltv_tkt_value has 21484 (30.5%) zeros | Zeros |
Lifetime Giving has 58829 (83.6%) zeros | Zeros |
days_to_donation has 1248 (1.8%) zeros | Zeros |
rolling_tkt_sum has 26312 (37.4%) zeros | Zeros |
Reproduction
| Analysis started | 2020-09-08 17:03:00.404623 |
|---|---|
| Analysis finished | 2020-09-08 17:04:58.844874 |
| Duration | 1 minute and 58.44 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
owner_no
Real number (ℝ≥0)
| Distinct | 38522 |
|---|---|
| Distinct (%) | 54.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2022525.081 |
|---|---|
| Minimum | 111 |
| Maximum | 2419301 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 111 |
|---|---|
| 5-th percentile | 397258.05 |
| Q1 | 1928112 |
| median | 2370216.5 |
| Q3 | 2391456 |
| 95-th percentile | 2413551.9 |
| Maximum | 2419301 |
| Range | 2419190 |
| Interquartile range (IQR) | 463344 |
Descriptive statistics
| Standard deviation | 629695.9448 |
|---|---|
| Coefficient of variation (CV) | 0.3113414765 |
| Kurtosis | 2.187826958 |
| Mean | 2022525.081 |
| Median Absolute Deviation (MAD) | 40994.5 |
| Skewness | -1.835938465 |
| Sum | 1.42329135e+11 |
| Variance | 3.965169829e+11 |
| Monotocity | Increasing |
| Value | Count | Frequency (%) | |
| 2335299 | 66 | 0.1% | |
| 1485790 | 64 | 0.1% | |
| 275098 | 48 | 0.1% | |
| 2289267 | 47 | 0.1% | |
| 2373627 | 47 | 0.1% | |
| 2140595 | 46 | 0.1% | |
| 2133270 | 44 | 0.1% | |
| 2375331 | 43 | 0.1% | |
| 2388599 | 43 | 0.1% | |
| 2387926 | 42 | 0.1% | |
| Other values (38512) | 69882 | 99.3% |
| Value | Count | Frequency (%) | |
| 111 | 3 | < 0.1% | |
| 258 | 1 | < 0.1% | |
| 262 | 2 | < 0.1% | |
| 267 | 5 | < 0.1% | |
| 853 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2419301 | 1 | < 0.1% | |
| 2419278 | 1 | < 0.1% | |
| 2419248 | 1 | < 0.1% | |
| 2419126 | 1 | < 0.1% | |
| 2419011 | 1 | < 0.1% |
| Distinct | 2160 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 2017-08-23 | 1301 |
|---|---|
| 2019-08-14 | 1024 |
| 2015-09-02 | 919 |
| 2016-09-07 | 822 |
| 2014-09-03 | 796 |
| Other values (2155) |
| Value | Count | Frequency (%) | |
| 2017-08-23 | 1301 | 1.8% | |
| 2019-08-14 | 1024 | 1.5% | |
| 2015-09-02 | 919 | 1.3% | |
| 2016-09-07 | 822 | 1.2% | |
| 2014-09-03 | 796 | 1.1% | |
| 2018-08-29 | 713 | 1.0% | |
| 2016-09-23 | 423 | 0.6% | |
| 2017-09-23 | 420 | 0.6% | |
| 2017-09-19 | 387 | 0.5% | |
| 2016-09-27 | 376 | 0.5% | |
| Other values (2150) | 63191 | 89.8% |
Unique
| Unique | 142 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct | 1159 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 107.3262916 |
|---|---|
| Minimum | 0 |
| Maximum | 5400 |
| Zeros | 34085 |
| Zeros (%) | 48.4% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 20 |
| Q3 | 156.6755609 |
| 95-th percentile | 432 |
| Maximum | 5400 |
| Range | 5400 |
| Interquartile range (IQR) | 156.6755609 |
Descriptive statistics
| Standard deviation | 197.7355773 |
|---|---|
| Coefficient of variation (CV) | 1.842377802 |
| Kurtosis | 64.08996281 |
| Mean | 107.3262916 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 5.40552422 |
| Sum | 7552765.793 |
| Variance | 39099.35852 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 34085 | 48.4% | |
| 40 | 1032 | 1.5% | |
| 20 | 953 | 1.4% | |
| 198 | 793 | 1.1% | |
| 38 | 761 | 1.1% | |
| 138 | 714 | 1.0% | |
| 238 | 695 | 1.0% | |
| 60 | 675 | 1.0% | |
| 100 | 659 | 0.9% | |
| 50 | 633 | 0.9% | |
| Other values (1149) | 29372 | 41.7% |
| Value | Count | Frequency (%) | |
| 0 | 34085 | 48.4% | |
| 1 | 1 | < 0.1% | |
| 2 | 4 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 14 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5400 | 1 | < 0.1% | |
| 5180 | 1 | < 0.1% | |
| 4588 | 1 | < 0.1% | |
| 4414 | 1 | < 0.1% | |
| 4292 | 1 | < 0.1% |
| Distinct | 131 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.020798045 |
|---|---|
| Minimum | 0 |
| Maximum | 5000 |
| Zeros | 68563 |
| Zeros (%) | 97.4% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5000 |
| Range | 5000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 42.71554863 |
|---|---|
| Coefficient of variation (CV) | 21.1379602 |
| Kurtosis | 6497.137924 |
| Mean | 2.020798045 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 69.13668969 |
| Sum | 142207.6 |
| Variance | 1824.618095 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 68563 | 97.4% | |
| 100 | 334 | 0.5% | |
| 10 | 217 | 0.3% | |
| 25 | 183 | 0.3% | |
| 50 | 128 | 0.2% | |
| 20 | 125 | 0.2% | |
| 5 | 97 | 0.1% | |
| 40 | 76 | 0.1% | |
| 2 | 47 | 0.1% | |
| 250 | 32 | < 0.1% | |
| Other values (121) | 570 | 0.8% |
| Value | Count | Frequency (%) | |
| 0 | 68563 | 97.4% | |
| 1 | 21 | < 0.1% | |
| 1.5 | 1 | < 0.1% | |
| 2 | 47 | 0.1% | |
| 2.2 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5000 | 2 | < 0.1% | |
| 2500 | 5 | < 0.1% | |
| 2250 | 1 | < 0.1% | |
| 2000 | 2 | < 0.1% | |
| 1500 | 1 | < 0.1% |
| Distinct | 2931 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 2017-08-23 | 824 |
|---|---|
| 2015-09-02 | 672 |
| 2014-09-03 | 635 |
| 2016-09-23 | 462 |
| 2014-09-23 | 446 |
| Other values (2926) |
| Value | Count | Frequency (%) | |
| 2017-08-23 | 824 | 1.2% | |
| 2015-09-02 | 672 | 1.0% | |
| 2014-09-03 | 635 | 0.9% | |
| 2016-09-23 | 462 | 0.7% | |
| 2014-09-23 | 446 | 0.6% | |
| 2014-09-26 | 424 | 0.6% | |
| 2016-09-15 | 416 | 0.6% | |
| 2016-09-07 | 410 | 0.6% | |
| 2014-09-22 | 407 | 0.6% | |
| 2015-09-28 | 378 | 0.5% | |
| Other values (2921) | 65298 | 92.8% |
Unique
| Unique | 281 ? |
|---|---|
| Unique (%) | 0.4% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct | 1398 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 1900-01-01 | |
|---|---|
| 2018-08-06 | 490 |
| 2020-03-26 | 226 |
| 2020-03-30 | 148 |
| 2020-03-25 | 100 |
| Other values (1393) |
| Value | Count | Frequency (%) | |
| 1900-01-01 | 58782 | 83.5% | |
| 2018-08-06 | 490 | 0.7% | |
| 2020-03-26 | 226 | 0.3% | |
| 2020-03-30 | 148 | 0.2% | |
| 2020-03-25 | 100 | 0.1% | |
| 2020-04-24 | 89 | 0.1% | |
| 2020-05-05 | 83 | 0.1% | |
| 2020-03-27 | 81 | 0.1% | |
| 2016-03-30 | 66 | 0.1% | |
| 2016-09-07 | 66 | 0.1% | |
| Other values (1388) | 10241 | 14.6% |
Unique
| Unique | 298 ? |
|---|---|
| Unique (%) | 0.4% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
geo_area_desc
Real number (ℝ≥0)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.674103337 |
|---|---|
| Minimum | 1 |
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 6 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.497853338 |
|---|---|
| Coefficient of variation (CV) | 0.8947197612 |
| Kurtosis | 5.987047599 |
| Mean | 1.674103337 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.620774255 |
| Sum | 117810 |
| Variance | 2.243564621 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 51168 | 72.7% | |
| 2 | 10277 | 14.6% | |
| 7 | 3473 | 4.9% | |
| 3 | 2428 | 3.5% | |
| 5 | 1503 | 2.1% | |
| 4 | 1080 | 1.5% | |
| 6 | 443 | 0.6% |
| Value | Count | Frequency (%) | |
| 1 | 51168 | 72.7% | |
| 2 | 10277 | 14.6% | |
| 3 | 2428 | 3.5% | |
| 4 | 1080 | 1.5% | |
| 5 | 1503 | 2.1% |
| Value | Count | Frequency (%) | |
| 7 | 3473 | 4.9% | |
| 6 | 443 | 0.6% | |
| 5 | 1503 | 2.1% | |
| 4 | 1080 | 1.5% | |
| 3 | 2428 | 3.5% |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.910319445 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros | 30829 |
| Zeros (%) | 43.8% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.946138595 |
|---|---|
| Coefficient of variation (CV) | 1.018750345 |
| Kurtosis | -1.09127187 |
| Mean | 1.910319445 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.4400920866 |
| Sum | 134433 |
| Variance | 3.787455429 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 30829 | 43.8% | |
| 4 | 11622 | 16.5% | |
| 3 | 11043 | 15.7% | |
| 2 | 6672 | 9.5% | |
| 5 | 5271 | 7.5% | |
| 1 | 2997 | 4.3% | |
| 6 | 1611 | 2.3% | |
| 7 | 181 | 0.3% | |
| 8 | 130 | 0.2% | |
| 9 | 13 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 30829 | 43.8% | |
| 1 | 2997 | 4.3% | |
| 2 | 6672 | 9.5% | |
| 3 | 11043 | 15.7% | |
| 4 | 11622 | 16.5% |
| Value | Count | Frequency (%) | |
| 10 | 3 | < 0.1% | |
| 9 | 13 | < 0.1% | |
| 8 | 130 | 0.2% | |
| 7 | 181 | 0.3% | |
| 6 | 1611 | 2.3% |
| Distinct | 2560 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 793.0981255 |
|---|---|
| Minimum | 0 |
| Maximum | 42312 |
| Zeros | 21484 |
| Zeros (%) | 30.5% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 149 |
| Q3 | 536 |
| 95-th percentile | 3740 |
| Maximum | 42312 |
| Range | 42312 |
| Interquartile range (IQR) | 536 |
Descriptive statistics
| Standard deviation | 2425.538425 |
|---|---|
| Coefficient of variation (CV) | 3.058308104 |
| Kurtosis | 94.91915165 |
| Mean | 793.0981255 |
| Median Absolute Deviation (MAD) | 149 |
| Skewness | 8.256546927 |
| Sum | 55811901.29 |
| Variance | 5883236.65 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 21484 | 30.5% | |
| 40 | 782 | 1.1% | |
| 20 | 758 | 1.1% | |
| 60 | 564 | 0.8% | |
| 38 | 500 | 0.7% | |
| 138 | 492 | 0.7% | |
| 238 | 476 | 0.7% | |
| 198 | 464 | 0.7% | |
| 78 | 452 | 0.6% | |
| 118 | 430 | 0.6% | |
| Other values (2550) | 43970 | 62.5% |
| Value | Count | Frequency (%) | |
| 0 | 21484 | 30.5% | |
| 2 | 2 | < 0.1% | |
| 4 | 13 | < 0.1% | |
| 5 | 7 | < 0.1% | |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 42312 | 31 | < 0.1% | |
| 33271 | 33 | < 0.1% | |
| 30819 | 64 | 0.1% | |
| 29997 | 31 | < 0.1% | |
| 21131 | 17 | < 0.1% |
| Distinct | 584 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4568.75912 |
|---|---|
| Minimum | 0 |
| Maximum | 3417602 |
| Zeros | 58829 |
| Zeros (%) | 83.6% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 490 |
| Maximum | 3417602 |
| Range | 3417602 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 106920.769 |
|---|---|
| Coefficient of variation (CV) | 23.40258399 |
| Kurtosis | 951.2318377 |
| Mean | 4568.75912 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 30.32802605 |
| Sum | 321512716.8 |
| Variance | 1.143205085e+10 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 58829 | 83.6% | |
| 100 | 792 | 1.1% | |
| 25 | 673 | 1.0% | |
| 10 | 488 | 0.7% | |
| 50 | 465 | 0.7% | |
| 20 | 266 | 0.4% | |
| 200 | 264 | 0.4% | |
| 5 | 204 | 0.3% | |
| 250 | 193 | 0.3% | |
| 40 | 161 | 0.2% | |
| Other values (574) | 8037 | 11.4% |
| Value | Count | Frequency (%) | |
| 0 | 58829 | 83.6% | |
| 1 | 38 | 0.1% | |
| 1.25 | 2 | < 0.1% | |
| 1.37 | 4 | < 0.1% | |
| 2 | 92 | 0.1% |
| Value | Count | Frequency (%) | |
| 3417602 | 64 | 0.1% | |
| 2061042 | 3 | < 0.1% | |
| 1042301 | 31 | < 0.1% | |
| 461460.08 | 15 | < 0.1% | |
| 357601 | 16 | < 0.1% |
prospect_board
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 1315 |
| Value | Count | Frequency (%) | |
| 0 | 69057 | 98.1% | |
| 1 | 1315 | 1.9% |
| Distinct | 1172 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52.23992497 |
|---|---|
| Minimum | -100 |
| Maximum | 3747 |
| Zeros | 1248 |
| Zeros (%) | 1.8% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | -100 |
|---|---|
| 5-th percentile | -100 |
| Q1 | -100 |
| median | -100 |
| Q3 | -100 |
| 95-th percentile | 1108 |
| Maximum | 3747 |
| Range | 3847 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 490.9563657 |
|---|---|
| Coefficient of variation (CV) | 9.398106256 |
| Kurtosis | 17.90792151 |
| Mean | 52.23992497 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.0617276 |
| Sum | 3676228 |
| Variance | 241038.153 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| -100 | 58782 | 83.5% | |
| 0 | 1248 | 1.8% | |
| -1 | 787 | 1.1% | |
| 1506 | 66 | 0.1% | |
| 177 | 64 | 0.1% | |
| 1 | 58 | 0.1% | |
| 153 | 52 | 0.1% | |
| 604 | 50 | 0.1% | |
| 109 | 49 | 0.1% | |
| 807 | 48 | 0.1% | |
| Other values (1162) | 9168 | 13.0% |
| Value | Count | Frequency (%) | |
| -100 | 58782 | 83.5% | |
| -1 | 787 | 1.1% | |
| 0 | 1248 | 1.8% | |
| 1 | 58 | 0.1% | |
| 2 | 14 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3747 | 25 | < 0.1% | |
| 3723 | 6 | < 0.1% | |
| 3716 | 7 | < 0.1% | |
| 3694 | 1 | < 0.1% | |
| 3683 | 13 | < 0.1% |
first_cont_order
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 1248 |
| Value | Count | Frequency (%) | |
| 0 | 69124 | 98.2% | |
| 1 | 1248 | 1.8% |
first_cont_after
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 60817 | 86.4% | |
| 1 | 9555 | 13.6% |
| Distinct | 4868 |
|---|---|
| Distinct (%) | 6.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 806.984696 |
|---|---|
| Minimum | 0 |
| Maximum | 153692 |
| Zeros | 26312 |
| Zeros (%) | 37.4% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 80 |
| Q3 | 310 |
| 95-th percentile | 3048.35 |
| Maximum | 153692 |
| Range | 153692 |
| Interquartile range (IQR) | 310 |
Descriptive statistics
| Standard deviation | 4194.586959 |
|---|---|
| Coefficient of variation (CV) | 5.197851929 |
| Kurtosis | 426.3247918 |
| Mean | 806.984696 |
| Median Absolute Deviation (MAD) | 80 |
| Skewness | 17.04718958 |
| Sum | 56789127.03 |
| Variance | 17594559.75 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 26312 | 37.4% | |
| 40 | 852 | 1.2% | |
| 20 | 754 | 1.1% | |
| 38 | 715 | 1.0% | |
| 138 | 658 | 0.9% | |
| 238 | 621 | 0.9% | |
| 198 | 601 | 0.9% | |
| 78 | 564 | 0.8% | |
| 60 | 550 | 0.8% | |
| 258 | 462 | 0.7% | |
| Other values (4858) | 38283 | 54.4% |
| Value | Count | Frequency (%) | |
| 0 | 26312 | 37.4% | |
| 2 | 3 | < 0.1% | |
| 4 | 11 | < 0.1% | |
| 5 | 7 | < 0.1% | |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 153692 | 2 | < 0.1% | |
| 152920 | 1 | < 0.1% | |
| 140320 | 2 | < 0.1% | |
| 140080 | 4 | < 0.1% | |
| 139980 | 1 | < 0.1% |
channel_desc_3rd Party
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 2657 |
| Value | Count | Frequency (%) | |
| 0 | 67715 | 96.2% | |
| 1 | 2657 | 3.8% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 203 |
| Value | Count | Frequency (%) | |
| 0 | 70169 | 99.7% | |
| 1 | 203 | 0.3% |
channel_desc_Chat
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 194 |
| Value | Count | Frequency (%) | |
| 0 | 70178 | 99.7% | |
| 1 | 194 | 0.3% |
channel_desc_Default Channel
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 63212 | 89.8% | |
| 1 | 7160 | 10.2% |
channel_desc_Email
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 2011 |
| Value | Count | Frequency (%) | |
| 0 | 68361 | 97.1% | |
| 1 | 2011 | 2.9% |
channel_desc_Fax
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 14 |
| Value | Count | Frequency (%) | |
| 0 | 70358 | > 99.9% | |
| 1 | 14 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 5511 |
| Value | Count | Frequency (%) | |
| 0 | 64861 | 92.2% | |
| 1 | 5511 | 7.8% |
channel_desc_Mail
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 333 |
| Value | Count | Frequency (%) | |
| 0 | 70039 | 99.5% | |
| 1 | 333 | 0.5% |
channel_desc_Mobile
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 62036 | 88.2% | |
| 1 | 8336 | 11.8% |
channel_desc_Online
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 35256 | 50.1% | |
| 0 | 35116 | 49.9% |
channel_desc_Phone
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 61875 | 87.9% | |
| 1 | 8497 | 12.1% |
channel_desc_Telefunding
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 70371 | > 99.9% | |
| 1 | 1 | < 0.1% |
channel_desc_Walk Up
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 564 |
| Value | Count | Frequency (%) | |
| 0 | 69808 | 99.2% | |
| 1 | 564 | 0.8% |
MOS_desc_External
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 59247 | 84.2% | |
| 1 | 11125 | 15.8% |
MOS_desc_Internal
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 41201 | 58.5% | |
| 0 | 29171 | 41.5% |
MOS_desc_Ticketing
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 52118 | 74.1% | |
| 1 | 18254 | 25.9% |
delivery_desc_Digital
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 43240 | 61.4% | |
| 0 | 27132 | 38.6% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 948 |
| Value | Count | Frequency (%) | |
| 0 | 69424 | 98.7% | |
| 1 | 948 | 1.3% |
delivery_desc_Mail
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 59870 | 85.1% | |
| 1 | 10502 | 14.9% |
delivery_desc_Will Call
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 54426 | 77.3% | |
| 1 | 15946 | 22.7% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 38198 | 54.3% | |
| 0 | 32174 | 45.7% |
facility_desc_Fundraiser
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 1916 |
| Value | Count | Frequency (%) | |
| 0 | 68456 | 97.3% | |
| 1 | 1916 | 2.7% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 48723 | 69.2% | |
| 1 | 21649 | 30.8% |
facility_desc_Other
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 1865 |
| Value | Count | Frequency (%) | |
| 0 | 68507 | 97.3% | |
| 1 | 1865 | 2.7% |
facility_desc_Perelman
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 62351 | 88.6% | |
| 1 | 8021 | 11.4% |
facility_desc_Small venue
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 4094 |
| Value | Count | Frequency (%) | |
| 0 | 66278 | 94.2% | |
| 1 | 4094 | 5.8% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| owner_no | order_dt | tot_ticket_paid_amt | tot_contribution_paid_amt | first_order_dt | first_cont_dt | geo_area_desc | Prelim Capacity | ltv_tkt_value | Lifetime Giving | prospect_board | days_to_donation | first_cont_order | first_cont_after | rolling_tkt_sum | channel_desc_3rd Party | channel_desc_At the Performance | channel_desc_Chat | channel_desc_Default Channel | channel_desc_Email | channel_desc_Fax | channel_desc_Internal Request | channel_desc_Mail | channel_desc_Mobile | channel_desc_Online | channel_desc_Phone | channel_desc_Telefunding | channel_desc_Walk Up | MOS_desc_External | MOS_desc_Internal | MOS_desc_Ticketing | delivery_desc_Digital | delivery_desc_Do Not Print Tickets | delivery_desc_Mail | delivery_desc_Will Call | facility_desc_Academy of Music | facility_desc_Fundraiser | facility_desc_Independence Mall | facility_desc_Other | facility_desc_Perelman | facility_desc_Small venue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 111 | 2015-10-07 | 138.0 | 0.0 | 2015-10-07 | 1900-01-01 | 1 | 5 | 366.0 | 0.0 | 0 | -100 | 0 | 0 | 138.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 1 | 111 | 2016-09-16 | 158.0 | 0.0 | 2015-10-07 | 1900-01-01 | 1 | 5 | 366.0 | 0.0 | 0 | -100 | 0 | 0 | 296.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 2 | 111 | 2018-09-21 | 70.0 | 0.0 | 2015-10-07 | 1900-01-01 | 1 | 5 | 366.0 | 0.0 | 0 | -100 | 0 | 0 | 366.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 3 | 258 | 2014-09-28 | 169.0 | 0.0 | 2014-09-28 | 1900-01-01 | 5 | 6 | 169.0 | 0.0 | 0 | -100 | 0 | 0 | 169.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 4 | 262 | 2014-10-02 | 45.0 | 0.0 | 2014-10-02 | 1900-01-01 | 2 | 4 | 90.0 | 0.0 | 0 | -100 | 0 | 0 | 135.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 5 | 262 | 2015-03-17 | 45.0 | 0.0 | 2014-10-02 | 1900-01-01 | 2 | 4 | 90.0 | 0.0 | 0 | -100 | 0 | 0 | 270.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 6 | 267 | 2015-04-16 | 0.0 | 0.0 | 2015-04-16 | 1900-01-01 | 1 | 6 | 1778.0 | 0.0 | 0 | -100 | 0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 7 | 267 | 2016-04-13 | 298.0 | 0.0 | 2015-04-16 | 1900-01-01 | 1 | 6 | 1778.0 | 0.0 | 0 | -100 | 0 | 0 | 298.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 8 | 267 | 2016-05-03 | 0.0 | 0.0 | 2015-04-16 | 1900-01-01 | 1 | 6 | 1778.0 | 0.0 | 0 | -100 | 0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |
| 9 | 267 | 2018-05-09 | 1400.0 | 0.0 | 2015-04-16 | 1900-01-01 | 1 | 6 | 1778.0 | 0.0 | 0 | -100 | 0 | 0 | 1698.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
Last rows
| owner_no | order_dt | tot_ticket_paid_amt | tot_contribution_paid_amt | first_order_dt | first_cont_dt | geo_area_desc | Prelim Capacity | ltv_tkt_value | Lifetime Giving | prospect_board | days_to_donation | first_cont_order | first_cont_after | rolling_tkt_sum | channel_desc_3rd Party | channel_desc_At the Performance | channel_desc_Chat | channel_desc_Default Channel | channel_desc_Email | channel_desc_Fax | channel_desc_Internal Request | channel_desc_Mail | channel_desc_Mobile | channel_desc_Online | channel_desc_Phone | channel_desc_Telefunding | channel_desc_Walk Up | MOS_desc_External | MOS_desc_Internal | MOS_desc_Ticketing | delivery_desc_Digital | delivery_desc_Do Not Print Tickets | delivery_desc_Mail | delivery_desc_Will Call | facility_desc_Academy of Music | facility_desc_Fundraiser | facility_desc_Independence Mall | facility_desc_Other | facility_desc_Perelman | facility_desc_Small venue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70362 | 2418866 | 2016-02-08 | 90.0 | 0.0 | 2012-10-04 | 2020-04-20 | 7 | 1 | 90.0 | 25.0 | 0 | 2755 | 0 | 1 | 90.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70363 | 2418866 | 2016-02-12 | 0.0 | 0.0 | 2012-10-04 | 2020-04-20 | 7 | 1 | 90.0 | 25.0 | 0 | 2755 | 0 | 1 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |
| 70364 | 2418931 | 2018-04-25 | 240.0 | 0.0 | 2018-04-25 | 2020-05-05 | 2 | 5 | 240.0 | 100.0 | 0 | 741 | 0 | 1 | 240.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70365 | 2418999 | 2016-10-01 | 0.0 | 20.0 | 2016-10-01 | 2016-10-01 | 1 | 3 | 124.0 | 20.0 | 0 | 0 | 1 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| 70366 | 2418999 | 2017-02-13 | 124.0 | 0.0 | 2016-10-01 | 2016-10-01 | 1 | 3 | 124.0 | 20.0 | 0 | 0 | 1 | 0 | 124.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70367 | 2419011 | 2018-09-07 | 0.0 | 25.0 | 2018-09-07 | 2018-09-07 | 2 | 5 | 0.0 | 50.0 | 0 | 0 | 1 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| 70368 | 2419126 | 2019-09-19 | 0.0 | 0.0 | 2019-09-19 | 1900-01-01 | 1 | 0 | 600.0 | 0.0 | 0 | -100 | 0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70369 | 2419248 | 2017-09-20 | 440.0 | 0.0 | 2017-09-20 | 2019-12-11 | 2 | 4 | 440.0 | 100.0 | 0 | 812 | 0 | 1 | 440.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70370 | 2419278 | 2015-04-13 | 395.0 | 0.0 | 2011-04-03 | 2003-03-26 | 1 | 3 | 752.0 | 75.0 | 0 | -1 | 0 | 0 | 395.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70371 | 2419301 | 2018-01-18 | 120.0 | 0.0 | 2018-01-18 | 1900-01-01 | 1 | 0 | 120.0 | 0.0 | 0 | -100 | 0 | 0 | 120.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |